home *** CD-ROM | disk | FTP | other *** search
/ Cream of the Crop 21 / Cream of the Crop 21 (Terry Blount) (October 1996).iso / business / tdsk3s10.zip / TRKSHORT.TXT < prev    next >
Text File  |  1996-08-13  |  46KB  |  201 lines
  1. (Instructions at M1)                        Commodity Trading Log                        Use this form only for short contracts.                        
  2.                         Short Contract                        Active: Yes or No as a note for your file.                        
  3.                                                 Contract: Contract month and year and the symbol.                        
  4.     Active:            Inititial Margin:            Date Sold:    =($A$14)                FTD: Final trading day.                        
  5.     Contract:            Maint. Margin:            Price Sold:                    Season High: Determine and enter.                        
  6.     FTD:            Commission:            Date Liquidated:                    Season Low: Determine and enter.                        
  7.     Season High:            Point Value:            Price Liquidated:                    "50% & 40% Retrace: These are automatically calculated, don't enter."                        
  8.     Season Low:            Starting Acct Bal:            P/L:    =(I5-I7)*F7-F6                Initial Margin: Determine and enter.                        
  9.     50% Retrace    =(C7+C8)/2        Initial Stop Loss:                                Maint. Margin: Determine and enter.                        
  10.     40% Retrace:    =(C9-C8)*0.4+C8        Trail Stop Loss:                                Commission: Determine and enter.                        
  11.                 Target Stop:                                Point Value: Enter the conversion factor required to convert from                         
  12.                             Trading                                          whatever price units you are using to effect on the                         
  13. Date    High    Low    Close    Profit    Profit    Stopped    Account    Margin                                      price of the full contract.                        Margin
  14.                 High    Low    Out    (Close)    Call    Comments            Starting Acct. Bal: The balance in your trading account when the        Trail    Target    Stop        Call
  15.                 =($I$5-C15)*$F$7-$F$6    =($I$5-$B15)*$F$7-$F$6    =(Q15)    =($F$8)+(($I$5-D15)*$F$7)-$F$6    =(S15)                                                  contract is sold.        "=(IF(B15>$F$10,1,0))"    "=(IF(C15<$F$11,1,0))"    "=(IF(OR(O15=1,P15=1),""Out"",""In""))"        "=(IF(H15<$F$5,""Yes"",""No""))"
  16.                 =($I$5-C16)*$F$7-$F$6    =($I$5-$B16)*$F$7-$F$6    =(Q16)    =($F$8)+(($I$5-D16)*$F$7)-$F$6    =(S16)                Initial Stop Loss: Decide and enter.        "=(IF(B16>$F$10,1,0))"    "=(IF(C16<$F$11,1,0))"    "=(IF(OR(O16=1,P16=1),""Out"",""In""))"        "=(IF(H16<$F$5,""Yes"",""No""))"
  17.                 =($I$5-C17)*$F$7-$F$6    =($I$5-$B17)*$F$7-$F$6    =(Q17)    =($F$8)+(($I$5-D17)*$F$7)-$F$6    =(S17)                "Trailing Stop Loss: Should initially be the same as the ""Initial Stop"        "=(IF(B17>$F$10,1,0))"    "=(IF(C17<$F$11,1,0))"    "=(IF(OR(O17=1,P17=1),""Out"",""In""))"        "=(IF(H17<$F$5,""Yes"",""No""))"
  18.                 =($I$5-C18)*$F$7-$F$6    =($I$5-$B18)*$F$7-$F$6    =(Q18)    =($F$8)+(($I$5-D18)*$F$7)-$F$6    =(S18)                "                                   Loss"" and then adjust as the price moves in"        "=(IF(B18>$F$10,1,0))"    "=(IF(C18<$F$11,1,0))"    "=(IF(OR(O18=1,P18=1),""Out"",""In""))"        "=(IF(H18<$F$5,""Yes"",""No""))"
  19.                 =($I$5-C19)*$F$7-$F$6    =($I$5-$B19)*$F$7-$F$6    =(Q19)    =($F$8)+(($I$5-D19)*$F$7)-$F$6    =(S19)                                                   price moves in your favor and according to your        "=(IF(B19>$F$10,1,0))"    "=(IF(C19<$F$11,1,0))"    "=(IF(OR(O19=1,P19=1),""Out"",""In""))"        "=(IF(H19<$F$5,""Yes"",""No""))"
  20.                 =($I$5-C20)*$F$7-$F$6    =($I$5-$B20)*$F$7-$F$6    =(Q20)    =($F$8)+(($I$5-D20)*$F$7)-$F$6    =(S20)                                                   trailing stop loss policy.        "=(IF(B20>$F$10,1,0))"    "=(IF(C20<$F$11,1,0))"    "=(IF(OR(O20=1,P20=1),""Out"",""In""))"        "=(IF(H20<$F$5,""Yes"",""No""))"
  21.                 =($I$5-C21)*$F$7-$F$6    =($I$5-$B21)*$F$7-$F$6    =(Q21)    =($F$8)+(($I$5-D21)*$F$7)-$F$6    =(S21)                Target Stop: Use this if you want to liquidate at a specific profit.        "=(IF(B21>$F$10,1,0))"    "=(IF(C21<$F$11,1,0))"    "=(IF(OR(O21=1,P21=1),""Out"",""In""))"        "=(IF(H21<$F$5,""Yes"",""No""))"
  22.                 =($I$5-C22)*$F$7-$F$6    =($I$5-$B22)*$F$7-$F$6    =(Q22)    =($F$8)+(($I$5-D22)*$F$7)-$F$6    =(S22)                "Date Sold: Enter nothing, this is referenced to the date you open"        "=(IF(B22>$F$10,1,0))"    "=(IF(C22<$F$11,1,0))"    "=(IF(OR(O22=1,P22=1),""Out"",""In""))"        "=(IF(H22<$F$5,""Yes"",""No""))"
  23.                 =($I$5-C23)*$F$7-$F$6    =($I$5-$B23)*$F$7-$F$6    =(Q23)    =($F$8)+(($I$5-D23)*$F$7)-$F$6    =(S23)                                    the position.        "=(IF(B23>$F$10,1,0))"    "=(IF(C23<$F$11,1,0))"    "=(IF(OR(O23=1,P23=1),""Out"",""In""))"        "=(IF(H23<$F$5,""Yes"",""No""))"
  24.                 =($I$5-C24)*$F$7-$F$6    =($I$5-$B24)*$F$7-$F$6    =(Q24)    =($F$8)+(($I$5-D24)*$F$7)-$F$6    =(S24)                Price Sold: Enter the price at which the order was actually executed.        "=(IF(B24>$F$10,1,0))"    "=(IF(C24<$F$11,1,0))"    "=(IF(OR(O24=1,P24=1),""Out"",""In""))"        "=(IF(H24<$F$5,""Yes"",""No""))"
  25.                 =($I$5-C25)*$F$7-$F$6    =($I$5-$B25)*$F$7-$F$6    =(Q25)    =($F$8)+(($I$5-D25)*$F$7)-$F$6    =(S25)                Date Liquidated: Enter the date you liquidated the contract.        "=(IF(B25>$F$10,1,0))"    "=(IF(C25<$F$11,1,0))"    "=(IF(OR(O25=1,P25=1),""Out"",""In""))"        "=(IF(H25<$F$5,""Yes"",""No""))"
  26.                 =($I$5-C26)*$F$7-$F$6    =($I$5-$B26)*$F$7-$F$6    =(Q26)    =($F$8)+(($I$5-D26)*$F$7)-$F$6    =(S26)                Price Liquidated: Enter the price at which the contract was actually        "=(IF(B26>$F$10,1,0))"    "=(IF(C26<$F$11,1,0))"    "=(IF(OR(O26=1,P26=1),""Out"",""In""))"        "=(IF(H26<$F$5,""Yes"",""No""))"
  27.                 =($I$5-C27)*$F$7-$F$6    =($I$5-$B27)*$F$7-$F$6    =(Q27)    =($F$8)+(($I$5-D27)*$F$7)-$F$6    =(S27)                                               liquidated.        "=(IF(B27>$F$10,1,0))"    "=(IF(C27<$F$11,1,0))"    "=(IF(OR(O27=1,P27=1),""Out"",""In""))"        "=(IF(H27<$F$5,""Yes"",""No""))"
  28.                 =($I$5-C28)*$F$7-$F$6    =($I$5-$B28)*$F$7-$F$6    =(Q28)    =($F$8)+(($I$5-D28)*$F$7)-$F$6    =(S28)                P/L: Enter nothing.  The profit/loss is calculated and includes the        "=(IF(B28>$F$10,1,0))"    "=(IF(C28<$F$11,1,0))"    "=(IF(OR(O28=1,P28=1),""Out"",""In""))"        "=(IF(H28<$F$5,""Yes"",""No""))"
  29.                 =($I$5-C29)*$F$7-$F$6    =($I$5-$B29)*$F$7-$F$6    =(Q29)    =($F$8)+(($I$5-D29)*$F$7)-$F$6    =(S29)                         commission.        "=(IF(B29>$F$10,1,0))"    "=(IF(C29<$F$11,1,0))"    "=(IF(OR(O29=1,P29=1),""Out"",""In""))"        "=(IF(H29<$F$5,""Yes"",""No""))"
  30.                 =($I$5-C30)*$F$7-$F$6    =($I$5-$B30)*$F$7-$F$6    =(Q30)    =($F$8)+(($I$5-D30)*$F$7)-$F$6    =(S30)                "Price Data: Paste or enter the Date, High, Low and Close for each"        "=(IF(B30>$F$10,1,0))"    "=(IF(C30<$F$11,1,0))"    "=(IF(OR(O30=1,P30=1),""Out"",""In""))"        "=(IF(H30<$F$5,""Yes"",""No""))"
  31.                 =($I$5-C31)*$F$7-$F$6    =($I$5-$B31)*$F$7-$F$6    =(Q31)    =($F$8)+(($I$5-D31)*$F$7)-$F$6    =(S31)                                    trading session that the position is open.        "=(IF(B31>$F$10,1,0))"    "=(IF(C31<$F$11,1,0))"    "=(IF(OR(O31=1,P31=1),""Out"",""In""))"        "=(IF(H31<$F$5,""Yes"",""No""))"
  32.                 =($I$5-C32)*$F$7-$F$6    =($I$5-$B32)*$F$7-$F$6    =(Q32)    =($F$8)+(($I$5-D32)*$F$7)-$F$6    =(S32)                Profit High: Enter nothing.  Calculated by subtracting the session's        "=(IF(B32>$F$10,1,0))"    "=(IF(C32<$F$11,1,0))"    "=(IF(OR(O32=1,P32=1),""Out"",""In""))"        "=(IF(H32<$F$5,""Yes"",""No""))"
  33.                 =($I$5-C33)*$F$7-$F$6    =($I$5-$B33)*$F$7-$F$6    =(Q33)    =($F$8)+(($I$5-D33)*$F$7)-$F$6    =(S33)                "                      low price from the price at which you sold the contract,"        "=(IF(B33>$F$10,1,0))"    "=(IF(C33<$F$11,1,0))"    "=(IF(OR(O33=1,P33=1),""Out"",""In""))"        "=(IF(H33<$F$5,""Yes"",""No""))"
  34.                 =($I$5-C34)*$F$7-$F$6    =($I$5-$B34)*$F$7-$F$6    =(Q34)    =($F$8)+(($I$5-D34)*$F$7)-$F$6    =(S34)                                      multipying by the Point Value and then subtracting the        "=(IF(B34>$F$10,1,0))"    "=(IF(C34<$F$11,1,0))"    "=(IF(OR(O34=1,P34=1),""Out"",""In""))"        "=(IF(H34<$F$5,""Yes"",""No""))"
  35.                 =($I$5-C35)*$F$7-$F$6    =($I$5-$B35)*$F$7-$F$6    =(Q35)    =($F$8)+(($I$5-D35)*$F$7)-$F$6    =(S35)                                      commission.        "=(IF(B35>$F$10,1,0))"    "=(IF(C35<$F$11,1,0))"    "=(IF(OR(O35=1,P35=1),""Out"",""In""))"        "=(IF(H35<$F$5,""Yes"",""No""))"
  36.                 =($I$5-C36)*$F$7-$F$6    =($I$5-$B36)*$F$7-$F$6    =(Q36)    =($F$8)+(($I$5-D36)*$F$7)-$F$6    =(S36)                Profit Low: Enter nothing.  Calculated by subtracting the session's        "=(IF(B36>$F$10,1,0))"    "=(IF(C36<$F$11,1,0))"    "=(IF(OR(O36=1,P36=1),""Out"",""In""))"        "=(IF(H36<$F$5,""Yes"",""No""))"
  37.                 =($I$5-C37)*$F$7-$F$6    =($I$5-$B37)*$F$7-$F$6    =(Q37)    =($F$8)+(($I$5-D37)*$F$7)-$F$6    =(S37)                "                      high price from the price at which you sold the contract,"        "=(IF(B37>$F$10,1,0))"    "=(IF(C37<$F$11,1,0))"    "=(IF(OR(O37=1,P37=1),""Out"",""In""))"        "=(IF(H37<$F$5,""Yes"",""No""))"
  38.                 =($I$5-C38)*$F$7-$F$6    =($I$5-$B38)*$F$7-$F$6    =(Q38)    =($F$8)+(($I$5-D38)*$F$7)-$F$6    =(S38)                                      multipying by the Point Value and then subtracting the        "=(IF(B38>$F$10,1,0))"    "=(IF(C38<$F$11,1,0))"    "=(IF(OR(O38=1,P38=1),""Out"",""In""))"        "=(IF(H38<$F$5,""Yes"",""No""))"
  39.                 =($I$5-C39)*$F$7-$F$6    =($I$5-$B39)*$F$7-$F$6